<?php
	require_once( 'core_DataBaseConnect.php' );
	require_once( '_configs.php' );
	
	class SettingDAO
	{
		// 지역 설정 정보 반환
		public static function selectRegion( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_REGION.' ORDER BY `ORDER`;';
			return $con->query( $query );
		}
		// 교육 설정 정보 반환
		public static function selectEducation( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_EDUCATION.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 군복문 설정 정보 반환
		public static function selectMilitary( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_MILITARY.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 정당 목록 반환
		public static function selectParty( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_PARTY.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 직급 목록 반환
		public static function selectRank( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_RANK.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 직책 목록 반환
		public static function selectDuty( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_DUTY.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 완수 목록 반환
		public static function selectCompleted( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_COMPLETED.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 사업 구분 반환
		public static function selectBusiness( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_BUSINESS.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 약력 구분 반환
		public static function selectHistory( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_HISTORY.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// SNS 구분 반환
		public static function selectSns( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_SNS.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 투표 구분 반환
		public static function selectVote( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_VOTE.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 참여 구분 반환
		public static function selectAction( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_ACTION.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 능력치 항목
		public static function selectStat( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_STAT.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
		// 가입 플랫폼
		public static function selectRegistPlatform( DataBaseConnect $con )
		{
			$query = 'SELECT * FROM '.configs::TABLE_CATEGORY_REGIST_PF.' ORDER BY `CODE`;';
			return $con->query( $query );
		}
	}
?>